Re: Environment variables

Hi Bruno,

Thanks: my .tcshrc works with this...

setenv PATH "$PATH":/Library/MySQL/bin
setenv PATH "$PATH":/usr/local/bin
setenv PATH "$PATH":/usr/local/pgsql
setenv PATH "$PATH":/usr/local/pgsql/bin

...so now I get this response...
[MacGregor:/Users/roy] postgres% pg_ctl  -D /usr/local/pgsql/data start
postmaster successfully started
[MacGregor:/Users/roy] postgres% LOG:  database system was shut down
at 2003-11-22 12:06:33 GMT
LOG:  checkpoint record is at 0/805FB4
LOG:  redo record is at 0/805FB4; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 490; next oid: 16977
LOG:  database system is ready


OK. Now I'm trying to get the PGDATA environment variable to work.
I've tried each the following lines in . tcshrc one at a time...
setenv PGDATA "$PGDATA":/usr/local/pgsql
setenv PGDATA "$PGDATA":/usr/local/pgsql/data
setenv PGDATA /usr/local/pgsql
setenv PGDATA /usr/local/pgsql/data
setenv $PGDATA /usr/local/pgsql
setenv $PGDATA /usr/local/pgsql/data

...and always get this response...
[MacGregor:/Users/roy] postgres% pg_ctl start
pg_ctl: no database directory or environment variable $PGDATA is specified
Try 'pg_ctl --help' for more information.
[MacGregor:/Users/roy] postgres%

...so what's going on?

regards,
Roy
--
--------------------
Roy MacGregor Paterson
MacGregorTech

t: +44 (0) 20 7584 7891
f: +44 (0) 20 7589 6223
m: +44 (0) 7803 163 938
w: www.macgregortech.com
e: roy@macgregortech.com
--------------------